UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SXSCNNKd9i8QOtzVynK51j1Y5drLYRGve3JleAA9gbA='
WHERE
key_id = '6697a2bc94805e12b2ab9bb167d2026607d215da69297fe9536e9ab4180e37f5'
AND (
token = 'SXSCNNKd9i8QOtzVynK51j1Y5drLYRGve3JleAA9gbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)