UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1EsmVOMsB5r2GLdeRhmWPJS16ZimSW8qp5OPg3i6l3I='
WHERE
key_id = '338c83dc514d8d4843659199912199fab39a32a22597c7025f54e64ddeddd2a1'
AND (
token = '1EsmVOMsB5r2GLdeRhmWPJS16ZimSW8qp5OPg3i6l3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)