UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J6kXXDCT3kr66nAn3XJZdiQGsQQde3kxQeItq9sLC8Q='
WHERE
key_id = '0e82fbff67cc34f1dcb0703d16331afc84f894e5f4f8331559f0890758bd30f5'
AND (
token = 'J6kXXDCT3kr66nAn3XJZdiQGsQQde3kxQeItq9sLC8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)