UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QT/ATlPryrjhenGn0DumXcemIuDTRnV4yNnr+3O/N8='
WHERE
key_id = '10eab36f14656fbf977497e8358ddcda41419353c8107b7a5f2ce13aec2d25df'
AND (
token = '6QT/ATlPryrjhenGn0DumXcemIuDTRnV4yNnr+3O/N8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)