UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eKNu8eNsqtE0qXpwuBElC0J6V0bsqrW6leLbN36yBM0='
WHERE
key_id = 'bdf8fbb63b58a7394ced82fde236af551d4c3011b400dffcfb0941b2b74c7d78'
AND (
token = 'eKNu8eNsqtE0qXpwuBElC0J6V0bsqrW6leLbN36yBM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)