UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7SZHQbVAJDoAowI5dndx/3ocjWGq1vyvoyFeY2wVvg='
WHERE
key_id = '28474c630448a306a06dd8515bda45bf314db15e617da69b1bf3c25df5155832'
AND (
token = 'K7SZHQbVAJDoAowI5dndx/3ocjWGq1vyvoyFeY2wVvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)