UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nh8TDhy+l4+bgaQLsi7OHv6rTN2G47nx7iTJXMCEdS0='
WHERE
key_id = 'a2412a4236447e3f2c04b049aee72700ee28548af596d3585d3f6776b19c72b9'
AND (
token = 'nh8TDhy+l4+bgaQLsi7OHv6rTN2G47nx7iTJXMCEdS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)