UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ydaiEk9aVOkGaEk+u5q9LVU8i1xHkHS534DeN3WLPHY='
WHERE
key_id = '7b40910e714dcc83c1171084cee4b4336d3301d47f80d4b5e72886d5b3fe2831'
AND (
token = 'ydaiEk9aVOkGaEk+u5q9LVU8i1xHkHS534DeN3WLPHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)