UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gH4LEZGxH9WljhqI5SpJpMcOrEZvUdDRjJXrvdgA6yw='
WHERE
key_id = '12e80aaf0fee5a243ac226e83c5d644b9ac53b562b16d3596af223c2755100e6'
AND (
token = 'gH4LEZGxH9WljhqI5SpJpMcOrEZvUdDRjJXrvdgA6yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)