UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bu5NcDl9ui2P/4Lc1amct9I7oEnaw/bcLKA5wy/P2uk='
WHERE
key_id = '9ed6bfb3d932c47c428ddcf696f7094762a752ca8aabae9e1e6507cf35d2a605'
AND (
token = 'bu5NcDl9ui2P/4Lc1amct9I7oEnaw/bcLKA5wy/P2uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)