UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M3VS3tpFfBobIrd0ttNeYFlwfsGoeBMyEmx8ho/r4N4='
WHERE
key_id = '2eaeb71c5fdb46cded874b0b0f250200a989a7703e7a2f1197b3344485ffc4b6'
AND (
token = 'M3VS3tpFfBobIrd0ttNeYFlwfsGoeBMyEmx8ho/r4N4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)