UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iE1qRdqQuLYbsaP40jb96u+dKzlbFnSMKrWisp91/kw='
WHERE
key_id = 'bacf032f800ccb310052f104589988d035b3be48256ae7a1527ce3dd22b6e4ec'
AND (
token = 'iE1qRdqQuLYbsaP40jb96u+dKzlbFnSMKrWisp91/kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)