UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmzIFG3dn7Yqlp6FK+gumrtp/T7v3Fg0P37QPXMqgDk='
WHERE
key_id = '9c12bcd902bb8bd7ceb70f35086f6f300b39dd8fb83da92e1f57df5ed78d9391'
AND (
token = 'pmzIFG3dn7Yqlp6FK+gumrtp/T7v3Fg0P37QPXMqgDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)