UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PqC6WE3NBPU5VdqnFl7supoAgfCE5X3OFAzp7L+NxY4='
WHERE
key_id = 'e2bbef78c58dba584a18ca6bb3f091165b15b79012dc8007fc0e532a63873323'
AND (
token = 'PqC6WE3NBPU5VdqnFl7supoAgfCE5X3OFAzp7L+NxY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)