UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hX5fYuQytMNYySX0rg1Z1A+BeCfbDzhGd3WGv4Ewm0g='
WHERE
key_id = '52d3f8849681851f3891e72392337a89638e94afe1f4c12d52e27f131743ef8a'
AND (
token = 'hX5fYuQytMNYySX0rg1Z1A+BeCfbDzhGd3WGv4Ewm0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)