UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0DkyuqaBLV4is2UWFntD4EPD4y15zkUyqJjVC7wt4bQ='
WHERE
key_id = 'c9af78c8f7641f4fecd0db129e01cc73e110e5f5ce474b96ab68b9e288a7089a'
AND (
token = '0DkyuqaBLV4is2UWFntD4EPD4y15zkUyqJjVC7wt4bQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)