UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VcMpIxl0X3XL9ZSpOPIc5nRmhKgyjqUOga8tNFrr0Yg='
WHERE
key_id = '2efe3d10920937693ed983d3798b13e051fd860b7bf20f98d40404fec5669b03'
AND (
token = 'VcMpIxl0X3XL9ZSpOPIc5nRmhKgyjqUOga8tNFrr0Yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)