UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7EWJiibHJRr3TXeJKC0uUqA+4gUN25RuZMBVBWMsnU='
WHERE
key_id = 'abc758db2de8541d8bb8931cd368a2314a11195f8c54f718c9cfd28776f5a304'
AND (
token = 'r7EWJiibHJRr3TXeJKC0uUqA+4gUN25RuZMBVBWMsnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)