UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PW1yiFqL5YCMgDtLrH4YiDf9LRjiEozQVbTsHNJmu04='
WHERE
key_id = '1c970375ed3c8cdaf617d0eda18749bfef2558fe0d8131bf81f3f71eb8e1b7b9'
AND (
token = 'PW1yiFqL5YCMgDtLrH4YiDf9LRjiEozQVbTsHNJmu04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)