UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30l7FlBjXsvJ8ovVGHTUV4ZRJqcGCKusUvPb5MyvSoE='
WHERE
key_id = '11f69485aa933214d3a34ab756d8cd98c795de873f0ce4116578503fcad4bcd0'
AND (
token = '30l7FlBjXsvJ8ovVGHTUV4ZRJqcGCKusUvPb5MyvSoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)