UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9znkd7XJWgcDVR/em/xGDVUanVutUtq8olX03a1zYTg='
WHERE
key_id = '48474a1d4c4ea47b712624d35122dfb2e27a44202e2e6c845f3ffe9c06d8f2fe'
AND (
token = '9znkd7XJWgcDVR/em/xGDVUanVutUtq8olX03a1zYTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)