UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42kejmbVA5STwHw0+yzMQL7lT8UWi1wJJ2Oz59h9Afg='
WHERE
key_id = 'd6fc642decb8a10ba8bba332ce11f7cf4c38091850a5ba1447664c47d7bcc9cc'
AND (
token = '42kejmbVA5STwHw0+yzMQL7lT8UWi1wJJ2Oz59h9Afg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)