UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9TgjIZXgJM1dOutyph42RnzgHG3C1LgRGvqY2leFmQ='
WHERE
key_id = '327ba7a05d6c993636ece4dcf35c983883a23583fd2e6224df90fb2282287176'
AND (
token = 'X9TgjIZXgJM1dOutyph42RnzgHG3C1LgRGvqY2leFmQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)