UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pSB8kHI5J84KkDyMvmtBHd1N0/tPVYtYavFAXbmoCw='
WHERE
key_id = '812cd2356bb7800d7015caaf0b1b136c13545f28d4f3deb8bbd9fa4c941acfb1'
AND (
token = '1pSB8kHI5J84KkDyMvmtBHd1N0/tPVYtYavFAXbmoCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)