UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cWtMNstlpp3XZ3xKz6wNovETf0bWQJIBVZHsjZTPdMs='
WHERE
key_id = '54b845e68c3d3cf664501b381af44023157d53913066dc2b1122773d8885a7fb'
AND (
token = 'cWtMNstlpp3XZ3xKz6wNovETf0bWQJIBVZHsjZTPdMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)