UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DnR5Z1rmfGAj2gzuk4GX4xnvkVbK0UWNE+CwUCv40i8='
WHERE
key_id = '734c7a486846ed9a66c9c8758f0d4d2f2e2df619edb146b03d0f24a4f1619f97'
AND (
token = 'DnR5Z1rmfGAj2gzuk4GX4xnvkVbK0UWNE+CwUCv40i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)