UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xABAJcJM5TGlhboKQiQfQgBhtI0EzqSH/gfhEJaY1A8='
WHERE
key_id = '3d6eecb0c82f36678f2edfd3cac6cf3531eea47dce61df9955aaf891f5338358'
AND (
token = 'xABAJcJM5TGlhboKQiQfQgBhtI0EzqSH/gfhEJaY1A8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)