UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Iddr1jy9eJQr1T3Gda8YjcFCjzrJ0lVHr6jesdWCTjo='
WHERE
key_id = 'b8e02681d047bf3d264e1d81b0fb23c76fb4aaebae8a46fe3903cf429f823007'
AND (
token = 'Iddr1jy9eJQr1T3Gda8YjcFCjzrJ0lVHr6jesdWCTjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)