UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOPShlQ9i1TuIWmm+42SwL9dJQcOarFu2rHCQABzbqM='
WHERE
key_id = '847d30ff0283152d4c4f114b8336a280ab5accba44607e1465978de81792e747'
AND (
token = 'QOPShlQ9i1TuIWmm+42SwL9dJQcOarFu2rHCQABzbqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)