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