UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bAWqlTUIqNQGnKpeQT7ZXQD53F77igdHKFUH8dPWqmk='
WHERE
key_id = 'd9027d95b697e8ad2ee343daa60381a6dd221cd914a02a372175584bdafa5259'
AND (
token = 'bAWqlTUIqNQGnKpeQT7ZXQD53F77igdHKFUH8dPWqmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)