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