UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tI4tU8/0imAU/R8OuUHgqA+X0/b/QGLpcCON9Zzw0oU='
WHERE
key_id = '7c21748c6be4195342668fb53ab8265d4fb9e4ab7d16802830804108d4850611'
AND (
token = 'tI4tU8/0imAU/R8OuUHgqA+X0/b/QGLpcCON9Zzw0oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)