UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bVWhwINp/U69HYxTCAYczLVJlgDAx7LLy8cxuNm8Sb4='
WHERE
key_id = '0dd486a6b23626990dbf0ff810619f9233c5831351eb001df6e57beea799fc60'
AND (
token = 'bVWhwINp/U69HYxTCAYczLVJlgDAx7LLy8cxuNm8Sb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)