UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z1v5sSTr7bc8YplXKXLD18AXqL1XTZ+YQSyz4TYhT4w='
WHERE
key_id = 'f6b9e24016b75cc30e9a5256138a0579ef7a9e5cee16a26b8ac198a26b76359e'
AND (
token = 'Z1v5sSTr7bc8YplXKXLD18AXqL1XTZ+YQSyz4TYhT4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)