UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pQSCOhpn6h+W5v40YhGIxfnnD1RU90+RfhRGcJTnCk='
WHERE
key_id = '196db93bff5033a06e93f0b628b8ebc9a018b4c5153882f4c4441e9e2a62aafa'
AND (
token = '8pQSCOhpn6h+W5v40YhGIxfnnD1RU90+RfhRGcJTnCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)