UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AmYFVzeLOZSxiEB1R4FCcgI5sI68PYlCzWQH1U9A2+8='
WHERE
key_id = 'bcaab9e86568cdc302446b6b1c80df6a6a246e362d8fd4c502285f7d9e2af5c7'
AND (
token = 'AmYFVzeLOZSxiEB1R4FCcgI5sI68PYlCzWQH1U9A2+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)